About

Srinivas Murthy Mathad is a Senior Analyst at Wipro Ltd with over 3 years of work experience in Informatica (ETL Tool), Oracle SQL, PLSQL, and UNIX. He has previously worked as a Software Developer at Ridisha Software Pvt Ltd where he gained hands-on experience in Extraction, Transformation, and Loading of Data directly from different heterogeneous source systems like flat files and Oracle using Informatica 9.x. Srinivas has expertise in creating mappings for implementing Slowly Changing Dimensions (Type1, Type2) and complex mappings development using Filter, Aggregator, Update Strategy, Union, Joiner, Router Transformation, etc. He is proficient in ETL Procedures, Star Schema, Snow Flake, Dimensions, and Fact tables. Srinivas has also created tables, Views, Constraints, Index (B Tree, Bitmap, and Function Based) and developed complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL. He has loaded data into Oracle Tables using SQL Loader and External Table and has experience in SQL performance tuning using Cost-Based Optimization. Srinivas has hands-on experience in Explain Plan and TKPROF and has expertise in PL/SQL concepts like exception handling, dynamic SQL. He also has hands-on experience in the Unix environment using Shell Scripting (CRONTAB) and has good knowledge of Unix Commands. Srinivas holds a Master’s Degree in Computer Engineering from Vishveshwaraiah Technological University. He has a relevant experience of 9.87 years and his technical skillset includes SQL, ETL, and Software Engineering.